| Column | Data Type | Nullable | Default | Description |
| TransactionID | int | not null | | Primary key for TransactionHistory records. |
| ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID. |
| ReferenceOrderID | int | not null | | Purchase order, sales order, or work order identification number. |
| ReferenceOrderLineID | int | not null | ((0)) | Line number associated with the purchase order, sales order, or work order. |
| TransactionDate | datetime | not null | (getdate()) | Date and time of the transaction. |
| TransactionType | nchar(1) | not null | | W = WorkOrder, S = SalesOrder, P = PurchaseOrder |
| Quantity | int | not null | | Product quantity. |
| ActualCost | money | not null | | Product cost. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |